System for managing customer orders and methods of implementation

ABSTRACT

The system of this invention manages customer orders using vendor supplied software systems interfaced on a real time basis to touch the data in each system on a real time basis. In effect, there is horizontal communication between the various components of the system such as inventory, purchasing, order management and receipt, logistics and inventory to have continual data flow without using a vertical software interface. As a result, customer orders are received on a real-time basis using screens that are user friendly to promptly take orders, and to verify customer data and verify the ability to meet those orders. Transmission of documents within the system is minimized thereby making it more efficient, timely and cost efficient.

This application is a continuation of U.S. Ser. No. 08/474/970 Now U.S.Pat. No. 5,758,329, issued on May 26, 1998 and filed on Jun. 7, 1995,which was a continuation U.S. Ser. No. 08/117/242 of U.S. Pat. No.5,666,493, issued on Sep. 9, 1997 and filed on Aug. 24, 1993.

BACKGROUND OF THE INVENTION

1. Field of the Invention

The present invention relates to a system for providing efficientmanagement and fulfillment of customer orders in a food processing anddistribution environment. More specifically, the invention relates to asystem having an: order management function, integrated with financialservices to process orders promptly and create current and efficientfinancial records. Likewise the system includes a logistics function forprocessing orders and consolidating them into appropriate loads fordelivery over transportation systems. Integrated in the system is aninventory management system that cooperates with the order managementfunction, financial services function and logistics function to properlymanage the raw material and finished product through a warehouse fordelivery to a customer. Also included in the system is a purchasingsystem based upon an electronic catalog that streamlines the purchasingfunction by using blanket vendor orders to approve the purchase of thenecessary materials to support the system.

2. Related Art

A software package named Flashpoint provided by Knowledge Ware, Inc. isutilized to create screens for customer service representatives. PRISMsoftware provided by Marcam is used to operate IBM AS/400 mini computersto support terminals using Flashpoint software. SMS software, suppliedby ITLS of Canada, resides on the AS/400 platform to support thelogistics function and TRACS software supplied by Westeley DevelopmentCorp., supports PCs driven by the TRACS software. Rhumba/400 Software issupplied by Wall Data, as well as PC Support by IBM to enablecommunications between an AS/400 platform and PC terminals. Furthermore,Software 2K provided by Software 2000 of Boston, Mass to supportfinancial functions. Marcam has issued U.S. Pat. No. 4,864,507pertaining to a method and apparatus for process manufacture control.The aforementioned vendor software and patent are hereby incorporated byreference.

None of the foregoing software is integrated to provide an efficientorder management system. In the past, these software packages operatedvertically. This prior architecture does not provide the necessarysystem integration for efficient real time data management.

SUMMARY OF THE INVENTION

The present invention has the ability to efficiently receive customerorders, process them, create appropriate financial records andcoordinate this information with the inventory and manufacturingfunctions to prepare and load consolidated shipments for transportationto a customer. This is accomplished by touching each sub-system's database on a real time basis by horizontal integration of each system tocreate a harmonious flow of data between systems. This unique conceptallows for continual updating of the system over time.

Most importantly, a deal with a customer is settled before the order istaken by using the horizontal data flow between systems to verifyavailability to meet the order, integrate customer data and price thedeal while speaking to the customer.

It is an object of this invention to efficiently receive and processcustomer orders.

It is another objective of this invention to minimize costs of a foodprocessing and supply business.

It is yet another object of this invention to create a system tailoredto customer profiles for the delivery of products.

It is still another object of the invention to efficiently manageinventory.

It is yet another object of the invention to efficiently assemble anddeliver loads of products to customers.

It is further an object of this invention to efficiently purchase andaccount for materials.

It is still another object of this invention to create a financialsystem to support each of the above objectives.

It is an object of this invention to create and integrate a systemincorporating the above features at minimal cost.

It is still another object of this invention to provide business controlfeatures to manage such a system.

BRIEF DESCRIPTION OF THE DRAWINGS

The invention is better understood by reading the following DetailedDescription of the Preferred Embodiments with reference to theaccompanying drawing figures, in which like reference numerals refer tolike elements throughout, and in which:

FIG. 1 illustrates an overview of the order management system.

FIG. 1 a illustrates the application software architecture.

FIG. 1 b illustrates the order management update and controls.

FIG. 2 illustrates the order fulfillment and architecture.

FIG. 3 illustrates an order fulfillment customer representative screen.

FIG. 4 illustrates an order fulfillment customer/master file maintenanceselection screen for use by a customer service representative.

FIG. 5 illustrates an order fulfillment screen for use by a customerservice representative to maintain customer master controls.

FIG. 6 illustrates a screen for order entry by a customer servicerepresentative.

FIG. 7 illustrates the order acceptance system.

FIG. 8 illustrates the system management software/TRACS architecture.

FIG. 9 illustrates, in diagrammatic form, the delivery process formanaging and executing the activities associated with inbound andoutbound movement of goods.

FIG. 10 illustrates diagrammatically the traffic management network ofall incoming and outgoing deliveries.

FIG. 11 illustrates the logistics system interfaces.

FIG. 12 illustrates the delivery subprocess for order delivery planning.

FIG. 13 illustrates the delivery process flow charts for orderconsolidation.

FIG. 14 illustrates the delivery subprocess for carrier selection.

FIG. 15 illustrates a delivery subprocess for load release.

FIG. 16 illustrates a delivery subprocess for freight claim management.

FIG. 17 illustrates a delivery subprocess for freight claim management.

FIG. 18 illustrates a delivery subprocess for freight claim management.

FIG. 19 illustrates a delivery subprocess for freightpayment/reconciliation.

FIG. 20 illustrates a delivery subprocess for proof of delivery.

FIG. 21 illustrates a product flow from receipt to the staging area forstorage and ultimately shipment.

FIG. 22 illustrates a flow chart of a transaction (TR).

FIG. 23 illustrates a system for hand-held warehouse reading devicesinterconnected to a dedicated network through a radio base for inputtingand receiving warehouse data.

FIG. 24 illustrates an inventory management normal cycle overview.

FIG. 25 illustrates a production receiving schematic.

FIG. 26 illustrates a vendor receiving schematic.

FIG. 27 illustrates a put-away schematic for identifying and placinggoods received.

FIG. 28 illustrates a schematic for workload planning for receivingorders and placing shipments.

FIG. 29 illustrates an order-pick schematic for selecting orders anddelivering to destinations.

FIG. 30 illustrates a batch-pick schematic for selecting orders anddelivering pallets of such orders to warehouse for put away.

FIG. 31 illustrates an order load and closeout schematic showing theprocess for documenting orders and their ultimate filing into the systemof this invention.

FIG. 32 illustrates a cycle count diagram for determining productscheduled for processing and movement to inventory as well as updatinginventory.

FIG. 33 illustrates year-end physical schematic to is provide a year-endinventory count.

FIG. 34 illustrates a consolidation schematic showing the process ofmoving goods to new locations for efficient storage and processing.

FIG. 35 illustrates a return schematic demonstrating the receipt ofgoods that are returned to either inventory or to quarantine.

FIG. 36 illustrates an outside storage schematic showing the movement ofgoods from inventory to storage and ultimately receiving.

FIG. 37 illustrates the standardized process and end solution forcreating an electronic catalog and system to support it.

FIG. 38 illustrates the relationship of an electronic catalog to thevarious components using it.

FIG. 39 illustrates the information stored in an electronic catalog.

FIG. 40 illustrates how the electronic catalog accesses information invarious data bases.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

In describing preferred embodiments of the present invention illustratedin the drawings, specific terminology is employed for the sake ofclarity. However, the invention is not intended to be limited to thespecific terminology so selected, and it is to be understood that eachspecific element includes all technical equivalents which operate in asimilar manner to accomplish a similar purpose.

I. Order Management

Referring to FIG. 1, it shows an overall schematic of the orderprocessing data flow, based on an IBM AS/400 platform. The figure isself-explanatory and will be amplified in the following description ofthis invention by reference to the specific figures that go into thenecessary detail.

Referring to FIG. 1 a, there is shown the software functions resident inthe networked AS/400s and interconnected PCs. The PRISM software resideson AS/400 1.a., Software 2000 resides on AS/400 1.b., and ShipmentManagement System (SMS) software resides on AS/400 1.c. AS/400's 1.a.,1.b., and 1.c. are networked and support PCs 1.d. each of which hasresident enabler software Flashpoint shown as 1.e. Also, residing inthese PCs are solution software 1.f. for creating DEALS, purchasinginterface, pricing and profitability (hereinafter described). The SMSsoftware in AS/400 1.c. supports PCs 1.g. having Flashpoint softwarei.e. and TRACS load builder software 1.h., hereinafter described. Theimplementation of both solution softwares (1.f. and 1.h.) are unique tothis invention.

Generally, the GUI (graphic user interface) consolidates the variousfields by pulling data from numerous screens into one screen used by acustomer service representative. When a specific field is entered, theinterface updates the supporting multiple screens thereby saving timewhile interacting with a customer. The resulting screen is user friendlyand responds to queries in real time.

PRISM software on the AS/400 platform interfaces with Flashpointsoftware on the PC platforms to allow the creation of the abovedescribed user friendly screens, and to interact with other modules ofthis invention. The enabler software between the PRISM customer ordermanagement software and the Flashpoint software is the Rhumba 400 andIBM PC support. This interface also talks to Software 2000 thatmaintains accounts receivable (A/R) files. It also allows for keepingseparate data stored in synchronization without having the data keyedin.

FIG. 1 b further describes the relationship of input devices (2 and 4)to the system which captures sales representative and customeractivities including financial data. Shown here is the use of Gelcochecks (6) and input devices (2 and 4) to input and manage DEALS (8).Gelco (6) is an existing vendor that allows checks to be written tocustomers for a variety of reasons. The Gelco checks (6) and informationfrom input devices (2 and 4) then are fed into the DEAL system (8), toproperly reflect discretionary spending. The information from the DEALsystem (8) is transmitted to the order management system and updates thecontrol function (10) where it creates activity reporting (12) to giveinput for sales representative reports, customer profitability reports,pricing reports and deals and discretionary reports. The informationalso flows from order management update control to pricing function (14)where the details of pricing are worked out using product costs, freightincrements, profit margin, market adjustment and other charges to createcorrect pricing. Likewise information flows from order managementupdates and controls to financial systems (16) where appropriatefinancial records are created. These include invoicing, credit memo,accounts payable checks, price lists and discount lists, among manyothers.

Referring to FIG. 2 the order fulfillment architecture has multipleinputs from computer integrated manufacturing systems at variouslocations as well as from warehousing data base (24). Information on theactivities at these various sites are fed into the central customerorder management (COM) (26) function and at the same time, informationis fed to a software package supplied by a vendor known as Software 2000(28). Accounts receivable and the general ledger functions are createdusing Software 2000 (28). The foregoing functions are performed on anAS/400 platform. Data from the customer order management system istransmitted to Flashpoint software (30), that resides on personalcomputers or like equipment such as work stations. This software is usedas a basis to create business scripts (32, 34, 36 and 38) that aredisplayed on each personal computer to aid customer servicerepresentatives in taking and creating orders.

FIG. 3 demonstrates one of the screens created for the order fulfillmentfunction used by a customer service representative. Shown in FIG. 3 arethe various files that have been created based upon the Flashpointsoftware. Unique to this system is the windowing of such files in onelocation for a customer service representative so that he or she doesnot have to page back and forth through the software while engaged in adiscussion with a customer to create an order. As a result, orders aretaken and fulfilled promptly in a real time mode because the file folderserves as a main menu which can be navigated using the mouse to select abusiness event unlike in the past where there was much delay in theprocess.

FIG. 4 shows another order fulfillment screen used by customer servicerepresentatives. It is entitled Customer Master File MaintenanceSelection and by use of a mouse the customer service representative canquickly navigate through the basic data on a customer and if necessaryupdate it based upon the interview. This submenu has been customized toa series of radio (40, 42) and push (44) buttons in order that themajority of the navigation can be accomplished by single mouse clicks.

FIG. 5 shows a further screen entitled Maintain Customer Master ControlScreen used by customer service representatives. This screen has thebasic data for each customer and once again can be navigated promptly toupdate it if necessary. If the information is correct it is the basisfor creating the customer records used throughout this system. Thisscreen is populated by data entered on previous screens in order thatthe screen user does not have to re-key, thus eliminating a potentialfor unsynchronized master files. Also, the “Bill To” and “Ship To”screen sequence is customized for this presentation. “Ship To” navigatesforward through related screens then automatically navigates in reverse,and activates Software 2000 customer maintenance files saving theoperator the navigation.

FIG. 6 is entitled Order Form and it has the basic information blocks tobe completed in creating an order by a customer service representative.This screen has the series of buttons added to easily allow access toadditional screens. The “Resource Description” (50) and “Sm” (52) fieldswere pulled in from other screens.

Shown in FIG. 4, 5 and 6 are radio buttons as well as well as normalpush buttons to indicate functions that may be selected by the operatorto allow real time navigation through the files supporting thesescreens. The feature of updating files forward and backwards results inerror free master files.

II. Financial

The Exception Resolution process design (103) involves putting inprocedures and policies to ensure customer service levels. This beginswith the order acceptance process all the way through the collection andapplication of cash. For any problems that arise, that process will haveprocedures and policies to handle and resolve them.

Referring to FIG. 7, Order Acceptance (100) is the beginning of theentire process. Data can enter the system via two ways, (1) manual entryfrom the customer service representative and the tool they use is aKnowledge Ware based application that interacts with the AS/400, PRISMsystem for manually taking orders or (2) by EDI transmissions. At orderacceptance the system goes through a variety of validations shown on theleft-hand side of this diagram as a process called Rule Validation(102). Validated order and customer attributes include, but are notlimited to, the order lead time required from the customer, theirdelivery schedules, delivery schedules can be met, their credit,available inventories and production times for their products and likerules. This feedback is conveyed to the customer while on the telephone.With the EDI scenario exception reports will be created and conveyed tothe customer.

Logistics (104) primary objective is to reduce the outbound and also theinbound freight costs of the organization. This is accomplished in acouple of ways (1) by using software to consolidate the less thantruckload shipments to different plants to have better utilization ofthe trucking operation. It also houses a low cost core carrier list tobe utilized to expedite shipping processes and to monitor theperformances of carriers.

Pricing (105) is in software residing on a LAN file server. It is gearedtowards looking at customers, markets and products. In addition, itbrings in other business data like product cost, profitability targets,where customer ship-to's are located, freight delivering cost to developdelivery pricing to customer and FOB pricing picking up shipper's dock.Included are market adjustments, overhead, et cetera, to be used tocompile and work out a customer product pricing. (Also seen on fig. 1b(14)).

Warehousing (106) is designed to ensure inventory accuracy, to put awayand retrieve inventory in an expedient fashion, to validate the order toensure what is loaded on the truck, and to ensure all documentationprepared for the shipment is accomplished.

DEALS (8) includes discretionary spending, negotiating deals withcustomers by writing them an AP check to rebate for performance,initiating a credit memo to them on account, giving them a “Gelco check”for buying advertisements, or buying down their price for specialpromotional activities that customers may undertake. Also, the salesrepresentatives will have the ability to put discount lists into thesystem via this DEAL system (8) to give them a special allowance. Thisinformation is fed into PRISM and shows an allowance off of theirinvoice when invoicing occurs. The sales representative can create acredit memo to issue invoice errors and apply the amount to a pre-setaccount.

This DEAL system (8) also houses the sales representatives' targets byproduct category and customer by which they will be measured. This alsogathers the data to support customer profitability reporting.

Performance Reporting (112) is where all the data comes together. Thisis outside of the AS/400 environment, on a LAN file server, to gatherdata from the order acceptance, the invoicing, the pricing, the shippingand the DEALS (8) function, plus brokerage fees to brokerage companiesthat service accounts. From this data is generated all of theperformance reportings such as sales representative activities, customerprofitability, analysis of movement trends and the like. There will be acustomer score card created to rate the customer for profitability,volume and the like. This data is used for management decisions relatedto this customer.

Order Fulfillment (114) is used after order acceptance and it gets theproduct picked and packed at the warehouse, closes the order, andgenerates all necessary documents.

Credit Memo (116), G/L (General Ledger) (118), AP (Accounts Payable)System (120), Accounts Receivable System (122), how customer credit isestablished, and procedures (how they interact at order entry time isimportant), and are all traditional accounting functions.

III. Logistics

Order Planning

Referring to FIG. 8 entitled SMS/TRACS Architecture, (SMS, also known asshipment management system) which is a vendor supplied software. Thediagram shown in this figure lays out the relationship of the hardwarein this system as well as the supporting software. It is understandableby one skilled in the art upon examining this figure and will only betouched upon lightly. The main frame has resident software for providingorder management. This software communicates with the AS/400 (150) whichis networked with other AS/400s to create the basic information network.Residing on the AS/400 (150) platform is the SMS Software supplied byITLS of Canada, and on the PCs the TRACS Software supplied by WesteleyDevelopment Corp. of Stamford, Conn. This combined software has thefunctions indicated on the drawing and also communicates with anaccounting function supported by Software 2000 (28). The SMS/TRACSsoftware residing in the AS/400 (150) further supports PCs (152) or workstations or the like with information generated by the AS/400 (150)resident software on rates, customer information and less than fulltruckload shipments. This software provides for consolidation of lessthan full loads, as well as creates shipment and load reports. Itlikewise creates information feeding back to the AS/400 (150) to createshipping instructions. The use of this hardware and software combinationuniquely supports the logistics system for load building. The loadbuilder function includes load tendering, load planning, loadconfirmation and load inquiry to build loads. This allows handlingmultiple orders to create a load.

FIG. 9 is a diagram of the delivery process for managing and executingactivities associated with inbound and outbound movement of goods. Shownin the diagram is the function of taking incoming orders (154) fromcustomers as well as distribution center replenishment, information onreturns and purchase of raw materials generated through Pos. Thisinformation flows to the order consolidation function (156) from whichinformation goes to the function for carrier selection (158). Thecarrier selection function (158), as further described hereafter, goesthrough a series of decision making steps to select the correct carrierfor the correct destination and load for that carrier and takes thisinformation and sends it to the load release receipt function (160)where data is created to input to the carrier monitoring function (162)as well as the shipment tracking function (164). From the shippingtracking function (164) information flows to the freight claimmanagement function (166) as well as the freight payment reconciliationfunction (168). There is feedback from the freight claim managementfunction (166) to the carrier monitoring function (162) as the case maybe. The carrier selection function (158), carrier monitoring function(162), shipment tracking function (164) and the freight payment function(166) all have EDI connections to customers to create data basesnecessary to support these functions.

FIG. 10 is a diagram of the traffic management network showing how goodsare received and distributed using the system. It is a system thatallows for multiple tracing of carriers available to deliver goods tocustomers.

FIG. 11 is a diagram of the logistics system interface. Shown in thisinterface are the various software and communications that support thesystem. The Software 2000 (28) supports the accounts payable function aspreviously described. PRISM software (170) supports the order managementfunction and Software 2000 (28) supports the accounts receivablefunction, all of which feed into logistics Systems (104) where thevarious bits of data created are used for support. From the logisticssystem (104) outbound orders (172) are received as well as internalinformation on the production of goods. The logistics system (104) isconnected through EDI (174) and fax (176) to carriers for tendering andaccepting delivery.

Referring to FIG. 12, Order Delivery Planning (300) is where orders arereceived from the order management system. The first action with theorders is to download them into the system, then sort them based on shipdate, and also by priority such as a quick delivery. For example, thereare orders for a particular shipping date, those orders would be sortedinto full truckloads including those that are LTL (less than atruckload) and customer pickup (the carrier or customer picks the orderup with their private fleet i.e., an XYZ truck or customer arrangestheir own carrier which means that XYZ arranges ABC carrier to come andpick it up). Referring to the schedule load appointment function in Box306, if it is a customer pickup, then an appointment is scheduled toactually come to the dock and load the product. The warehouse keeps alist of appointments and times, (i.e., eight trucks can load in onehour, and therefore there are eight time slots for one hour increments)and records the trucks schedules. The dotted line is for the carrier toactually call in and confirm or set the appointment with the warehouse.The arrow coming down indicates that the truck will be loaded when thecarrier arrives.

If it is not a customer pickup, go to the Full Truckload decision in Box308 which questions a full truckload or not. Full truckload means didthe customer order an entire truckload, with their product or is theirorder on two separate truckloads. For example, is there half an order offrozen and half an order of chilled orange juice? In the present system,these are two separate orders, and therefore do not create a fulltruckload even though in theory it would be a full truckload. If thereis a full truckload you go to “carrier selection” which will be two orthree processes down the decision tree. If you don't, the orders arepassed onto order consolidation. Again, the process here is to determinewhich are full truckloads and which are LTL shipments. The LTL shipmentswould again go to the order consolidation function which is one of thekeys to the entire process.

Order Consolidation

Referring to FIG. 13, Box 310 this is the same decision process that wasmade in the order delivery planning process of FIG. 12, but instead, ifa full truckload the arrow goes to the left and goes down to carrierselection. There is no need to go through consolidation because it is afull truckload. If it is not a full truckload, go to the orderconsolidation function of Box 312. This results in putting LTL shipmentsinto a full truckload. The system goes through certain decisions todetermine what is the optimal truckload. The next few boxes aredecisions which are made by the software. The AS/400 is able to loadbuild correctly on its resident logic. It is a matter of a logisticplanner's judgment to override the internal logic. For the majority ofthe loads, the load decision is made in the PC based software package toperform the optimal consolidation. The decisions that the actualsoftware goes through are based on a transportation algorithm, insoftware on the AS/400 Platform shown in Box 314. It looks at a deliverywindow which means when does that product need to be delivered? Mostorders are sorted by shipment date. If an order is shipped on Tuesday,the query is when does it need to be delivered? The query is, how longdoes it take for a product to get to a certain area, in other words,from Dade City to California it could take two days, but from Dade Cityto Las Vegas it also might take two days. This data is used to decidewhether those two orders can go on the same truck, i.e., can it fit thedelivery window based on the guaranteed delivery date for that customer?The system looks at a window delivery and asks if the loads can beconsolidated based on transit time, et cetera.

Further, the function shown in Box 316 asks if they can be consolidatedif the delivery window is compatible and if the customer shipped to isthe same?

The next decision is shown in Box 318 and asks if it is a truckload? Ofcourse, if a full truckload is determined there is no need to proceed.This would be the optimal consolidation if a half a truckload of frozenand a half a truckload of chilled orange juice go to the same customer.Then you have a full truckload going to the same customer and deliveredon the same day, for optimal consolidation. If the arrow to the leftsays there is a full truckload, the decision tree goes down immediatelyinto carrier selection.

If the decision shown in Box 320 says there is not a full truckload buttwo orders are going to the same customer, it then looks at other ordersgoing in the same destination area. There is basically one more checkwithin the destination area. If not, it goes back into the rest of theorders for the next consolidation which is the arrow to the right.

If it is in the same destination area, then it goes to Box 322 theorigin area locations 1 and 2. The system would try to put all ordersfor location 1 before putting location 2. If not in the same origin areathe arrow goes to the right and it goes back into potentialconsolidation with other orders. If yes, it is in the origin area, thenthe decision arrow going down indicates it might be consolidated.

The decision shown in Box 324, “form”, means the form of the product,i.e. frozen, chilled or dry, because the way it is loaded in the truckmakes a difference. Frozen goes in the nose of the truck, followed bychilled, and then dry. The reason for this is the location of thecooling unit. Therefore, these should be loaded exactly opposite of theway the truck is built. Stop 1 would be dry, stop 2 chilled, and stop 3frozen to prevent unnecessary unloading. Consolidation is determined inthis form.

The decision shown in Box 326 is the consolidation process. Thepreceding decisions result in the consideration input to Box 328 toconsolidate loads by picking the furthest and latest point away and tobuild the truckload from that information.

The decision of Box 330 is to select the next closest, i.e., shipment toLos Angeles and San Francisco (next closest). It looks at the nextclosest load that fits the other requirements (form, destination,origin, et cetera).

The decision of Box 332 says does it fit the time and capacity? Capacitymeans “x” amount of weight and truckload (for juice it is about 44,000lbs, meat 36,000 lbs). The difference being that the meat product ispacked different on the pallet to only get about 20 pallets on a truck,and the way the meat is stacked results in about 36,000 lbs, not fullycubed out most of the time. Juice products are case goods that arestacked accordingly and can obtain fully cubed out pallets of about44,000 lbs. Therefore, two 25,000 lb juice orders cannot be sent on thesame truck or the load will be 50,000 lbs and the truck wouldbe/overweight and not legal.

If the decision is yes, then go to Box 334 which taken the data thatthere is 44,000 lbs of juice or 36,000 lbs of meat. This data iscompared to maximum truckload weight. If, the comparison shows that theweight of the load approached the maximum truckload weight then theorder consolidation is finished. If not, then more orders need to bepicked to get up to that truckload amount.

If yes, the consolidation is finished, then go to Box 336 and answerwhat is the cost of delivering these orders. The cost of full truckloadrates is built into the system for carrier X.

The next decision Box is 338 which asks if that is acceptable. Thelogistics planner is going to use his judgment when he sees what thesystem calculates and the cost. If not acceptable, then it will go backto consolidation and possibly change the parameters. It might be donemanually with the system actually calculating the difference in freight.If it is not acceptable, there is the option to do a manual load build.

If acceptable, go to Box 340 which queries if it is a full truckload?This means that it may not be a full truckload and there may only be somany orders which can be consolidated or weighted out (i.e., 44,000lbs). If there are not enough full truckloads from of all these orders,which does occasionally happen, some LTL carriers do their own loadconsolidation and pick up small orders from various customers and go toa dock and break bulk terminal to put loads together on the same truck.These carriers are more costly due to the personal consolidation andhandling of the product. The ultimate goal is to build full truckloadsto lower the freight costs rather than have someone else do it.

If not, go to LTL carrier assignment. The lowest cost LTL carrier shouldbe tendered the load. If it is a full truckload go directly to carrierselection, which is assignment of a full truckload carrier. Either way,there is a carrier selection process.

Carrier Selection Process

Referring to FIG. 14, beginning with the economic truckload decisionshown in Box 342, meaning from a weight standpoint it may make sense toactually build it as a truckload even though its not fully weighted outsuch as a meat delivery.

The decision point in Box 344 is customer requested carrier. A customermay request a specific carrier. If yes, it goes to Box 352 which says tonotify a carrier that they have a load. This comes later in the decisionprocess.

If not, the decision goes to Box 346 and asks if any of the in-housefleets want the load. If not, go to Box 348 carrier assignment. Adatabase has been designed and set up which contains all of thecarriers, service areas and rates. It looks at all the carriers andpicks a carrier from the list which is decision Box 350.

Decision Box 350 determines from a list of carriers that haul productsto the service area(s) to which the load is destined. The carrier listidentifies the carriers and their rates to selected areas. The load isthen tendered to the selected carrier with the lowest rate, but thelowest may not have the right equipment available and therefore thedecision is made to offer to carrier B. Therefore, the decision is notonly the lowest cost carriers with available equipment.

The decision Box 360 feeds into the decision process of Box 350 andinputs carrier monitoring process which helps determine which carrier tobased on different factors and not on just the cost factor alone. Eventhough carrier A may be the lowest cost carrier its service rate may beless than 100%,e.g. 90%, while and carrier B may be 99% and only cost$10.00 more. Then the decision is made use carrier B because of theservice level considerations. If none of the carriers have equipmentavailable to haul the load, then the decision goes to in-house carrier.Assuming that a carrier was not found, the process goes to Box 346. Atcertain times of the year it has been found difficult to assign carriersto products, necessitating the use of in-house fleets.

Decision Box 352 notifies the carrier. This may be done by telephone orEDI. If via EDI, the carrier may access their mailbox and say yes or no.There are certain transaction forms that are generated. One is a loadtender form 990 that the carrier would send back with an acceptance orrejection of the load. If carrier's are on EDI it would be an efficientprocess. There is also a load tender form which is not in any of theseother process boxes which states what the contents of the load are, forexample, the customer, weight, product type, delivery date, et cetera.Rather than relay over the phone, a fax including the information issent to the carrier via the load tender form requesting the carrier'ssignature if the load is accepted. After acceptance, the executed formis returned via fax. The manual notification of the carrier process isby fax, phone or a combination thereof. EDI is however the preferredmeans.

Decision Box 354 is a less than truckload shipment. Certain orders areLTL shipments and need to go through a carrier selection process.

Decision Box 356 queries if the customer requested an LTL carrier? Thereare only a few carriers that haul LTL shipments. If it is not a customerrequested carrier, then the process goes the regular carrier assignmentdecision in Box 348. The decision is no different for an LTL shipmentthan for a full truckload regarding carrier assignment considerations.The service level of LTL is also considered. In other words, carrier Amay be a truckload only going to that area and truckload B may be a LTLcarrier going to that service area. If the LTLs go to California, thedecision is to pick that carrier.

Decision Box 356 first determines if there is a customer requestedcarrier then goes through the carrier selection process of Box 352.

Decision Box 358 instructs that the carrier is to confirm theappointment, meaning that they will pick up the product at thewarehouse. This process is done by the carrier calling the warehouse andconfirming the appointment. If they do not confirm the appointment, thenthe load is canceled and process follows the exact same selectionprocess, and reassigns the carrier's load to another carrier.

As discussed above, decision Box 360 feeds into the carrier selectionprocess. The carrier monitoring process sets the standards a carriermust meet before it is selected. Criteria are established such as 98% ontime delivery, or 1 1% claims, meaning damaged products, short, productsor overages that are related to the carrier. In other words, the loadcould be shipped short which/would not be the carrier's fault, but ifthe carrier has continual shortages, this needs to be tracked. Thecarrier monitoring process also considers the number of times a carrierrejects a load. For example, if 10 loads were offered and only 8 wereaccepted, it could mean unavailable equipment. Another criteria is thetime it takes to pick up the order at the warehouse, and if they arelate. This is considered an exception to on time pick up. If thestandard is 98% on time and they are 97% on time this information needsto be captured. The carrier is required to furnish the actual deliverydate. The result is a report or score card which gives them a rating.The selection process is used to weed out the carriers that do notprovide the required service level. Based on the report card, thecarriage may be rebid to other carriers.

Load Release

Referring to FIG. 15, decision Box 362 basically outputs that the orderwas received from order management and has been through the carrierselection process, load consolidation, et cetera because for loadrelease purposes the order that the loads are going to be put on thetruck, which loads are going to be put together on the same truck, etc.is required.

Decision Box 364 is the order release portion. At that point there is adecision as to whether the order is going to be shipped. Logistics wouldactually confirm and send it to the warehouse to be shipped.

Decision Box 366 instructs to generate a pick ticket. A pick ticket issomething that is used by the warehouse to determine the location that aproduct is stored. It shows the products to be put on the truck by SKUlevel. It states for example that 100 cases of Florida Gold and a 64 oz12 (12 64 oz to a case) are needed. It may then pick 100 cases of OldSouth Premium chilled orange juice 8 oz bottles that are 84 to a case.It locates the product by SKU level and instructs placement on the truckby order. It may have multiple orders for one truckload. Box 374, goingoff the order release in decision box 364 is another pick ticket whichis the same as decision Box 366.

Decision Box 376 is where the truck is actually loaded. Again, the truckmust be loading taking into consideration the commodity type of theload. Decision Box 376 determines how to actually load the truck,frozen, chilled and dry.

Decision Box 368 determines that the load needs to be closed. At thetime the load is closed, the SMS software in the warehouse produces ascreen that says the load that is going to the Supervalue in Omaha,Nebr. consists of 200 cases of Florida Gold and 300 cases of Old Southat a particular weight. In order to change the count, a warehouse personmust verify the count, in other words override the 200 cases of FloridaGold to 201. The weight is either manually- or automatically calculated.At that time the Bill of Lading is generated, by the PRISM softwaresystem using an SKU number so that a change in quantity wouldautomatically change the data on the weight. A four digit alpha codedesignating the carrier is used to produce that information directly onthe Bill of Lading, closing the load and generating the Bill of Lading.

Decision Box 370 means that information feeds into the invoices. It isfed into by Box 368 as well for indicating that the product was shipped.As a result, an invoice is created.

Decision Boxes 370 and 372 are information outputs which feed to thefinancial data base.

Returning to decision Box 380, a Bill of Lading is generated, which is alegal document that the carrier must retain on the truck at all times ashe is hauling the product. This states the products that are on thetruck; where the products are being delivered, and the carrier. It is alegal document required by the ICC for shipments on interstate highways.A Bill of Lading is generated by the system after the information in Box368 is inputted to close out the load.

Decision Box 382 determines that the driver signs the Bill of Lading.The driver basically signs that he received that product. For example,decision Box 382 indicates that the driver received in the truck 200cases of Florida Gold orange juice. When the load reaches itsdestination and the customer says they only received 199 cases, thecarrier can be held accountable. The carrier basically signed to saythat they received and are responsible for 200 cases of product. Thesigning also makes the Bill of Lading a fully executed document forlegal purposes.

Decision Box 382 indicates that the Bill of Lading on file should havebeen executed by the driver to verify any information that may needed ata later date.

Decision Box 384 is a completed Bill of Lading after the driver signsit.

Freight Claim Management

Referring to FIG. 16, decision Box 386 indicates a phone call from thecarrier/customer. The carrier has to call while at the customer's dock,but the customer could also be the one that calls. At this point theprocess goes to freight claim management in decision Box 388 if there isa claim.

Decision Box 390 is when a phone call is received from the carrier orcustomer, a sequential incident number is assigned. It is called anincident number because at that point there is no decision as to whetherit is going to be a claim or not. It tracks all instances of overages,shortages, and damages (OS&D).

Decision Box 400 says to generate any credit/debit memo for any OS&D. Ifafter going through the entire claim process and determining that thereis an OS&D and the shipper is at fault, then a debit and credit memo isgenerated so that it is outside of the normal process. If there is anOS&D involved the customer will not pay for that. If the customerordered the 200 cases of Florida Gold orange juice and only received199, short 1 case, it will only pay for 199. A debit/credit memo isgenerated to accounts receivable so that when that customer pays forthat invoice its only going to pay for 199. The customers accountsreceivable is then updated.

Decision Box 410 indicates to notify an order management caseworker ofreported shortages and damages. In other words, the carrier calls andreports the customer's shipment was short or damaged. Order managementis then notified.

Decision Box 412 indicates to notify a caseworker to be proactive withcustomers to settle potential claims.

Decision Box 414 indicates that because there is a reported shortage ordamage to notify the warehouse to resolve inventory discrepancies.

Decision Box 416 determines what to do if a damage Referring to, FIG.17, decision Box 418, a damage report that has been made. Damage reportsare handled directly from an overage or shortage. An investigation isconducted resulting in a report which states the circumstancesconcerning the freight claim.

Decision Box 452 indicates to record the damage reason in the incidentdatabase. This is done to identify if a particular product keeps gettingdamaged in transit. The information is recorded in this database fordamage from packaging, carrier mishandling, etc. to track the damages byreason code to correct the situations. With carrier problems this can betransferred to their report card as part of the carrier monitoringprocess.

Box 420, queries if this is an in-house carrier? The reason for thisdetermination is because in-house carriers are treated differently. Ifyes, go to decision Box 422 and the report is resolved within 48 hours.At that point it may take some investigation to determine who was atfault. If its not resolved within 48 hours (maximum amount of time on aninternal claim) the process goes to decision Box 436, explained later.If resolved within 48 hours, and fault assigned, the process goes todecision Box 424.

Decision Box 426 assigns the cost for damage to a carrier or shipper.

Decision Box 428 determines whether the actual amount of damage is over$25.00. If so, a claim is filed with the carrier in decision Box 440.There is a nine month period in the United States and three months inCanada for filing an ICC claim/form which identifies the product, thedamage and the dollar amount.

Decision Box 420, is basically the same decision that is made for anoutside carrier that is, made for an in-house carrier. If the carrier isat fault, the process goes to Box 428 and determines if the amount ofdamage is $25.00. The process then goes through the decision whether a aclaim is to be filed. If the carrier is not at fault, the shipperabsorbs the cost of the damage.

Decision Box 432 is a damage report to find out why there is continuingdamage. The incident database was created in order to generate this typeof damage report. The decision Boxes 432, 434, 436, and 418 are directedto handling non-damaged, that is short or over products. First, adetermination is made whether the report shows an OS&d; over $25.00. Ifyes, the process goes; through the regular investigation and handles thedamage report accordingly

Referring to FIG. 18 in decision Box 442, (note previous page) thecarrier has 90 days (set by ICC) to respond to a claim and acknowledgeit. There is a standard acknowledgement form.

If not in 90 days, the process goes to decision Box 444 where a claimtracer is generated which states a claim was filed, and inquires why thecarrier has not the carried does respond. If responded in 90 days, it isacknowledged. Otherwise the carrier must confirm that they received theclaim and are researching it. Nothing needs to be settled in this 90 dayperiod. A follow up on the promptness of the settlement is used forcarrier scorecard.

In decision Box 448, if the claim is resolved, then the carrier pays thesettlement; In decision Box 450, if carrier doesn't pay within a 60 dayperiod, the loss resulting from the damage is deducted from the freightbill per an agreement with the carrier.

Freight Payment/Reconciliation Process

Referring to FIG. 19, this is the process to pay the carrier for theirfreight.

Decision Box 454 is PRISM software. The arrow down indicates that anorder is passed whether full or LTL to logistics. Logistics does itswhole process and goes through load consolidation and carrier selection(note the rate established for the carrier). This rate information thenis fed back into PRISM.

Decision Box 456 provides that because the carrier is known there is noneed to perform a reconciliation anymore. A carrier sends a freight billincluding mileage, stop off charges, dividers, requiring a 100% audit ofthose freight bills back to the Bill of Lading. On the Bill of Lading ishand typed the actual amount of freight that is expected to be paid.Again, the carrier selection process lists the carrier and the ratesthey charge so when a carrier is selected and they've accepted the load,the system actually takes that freight amount and prints it on the Billof Lading. This allows the freight bill to be used, is performing areconciliation, and pay the carrier directly by going and approving thepayment (a final check before releasing those bills for payment).

Below decision Box 456 is payment approval that may be going on once aweek by paying carrier ABC for all the loads hauled in that week togenerate one invoice in a summary type format that shows the loads thatwent out in that five day period. Then the “hold five days” initiallyfor the purpose of taking into account additional charges that may occurwhile delivering the load. For example, the driver may be retained at acustomer's dock for a specific reason, resulting in a detention charge,so the carrier may bill for that depending on the rules that are ineffect for their rate. All such information is captured within thatfive-day period. Five days is not fixed so the system can be modified tohave a separate adjustment process where the initial estimated freightcharges are used based on what is shown on the carrier selection processand a separate adjustment charge made when this detention occurredresulting in an adjustment to that particular invoice/order number. Forexample, once a week, all payments due to carrier ABC are sent fromdecision Box 456 indicating to make a freight payment, to S2K softwarein finance. The payment request would be interfaced into accountspayable. The coding is performed within the logistics process using theaccount numbers with an interface into accounts payable.

The line item out to the right of the hold five days area called“delivery proof/freight bill” is a request for the carrier to send proofof delivery on all freight bills on an exception basis.

Proof Of Delivery

Referring to FIG. 20, decision Box 458 indicates the carrier arriving atthe customer's warehouse and unloading which is decision Box 460. Duringthat unloading process, the carrier gives the warehousemen at thecustomer's dock a detailed list of all the products that he isdelivering by SKU. The warehousemen at the customer's dock isresponsible for confirming the condition and quantity of the load. Atdecision Box 462 it is determined if there needs to be any changes tothe Bill of Lading for OS&D. The customer would actually change the Billof Lading as part of decision Box 462.

The process goes to decision box 464, and if there are any OS&D, thecarrier needs to notify the caseworker. The carrier is required while atthe customer's dock to call and say if there is a problem (discussedearlier). He needs to notify the shipper again to be proactive with thecustomer and the shipper determines if a back order or shipment isneeded, or whatever else, to satisfy that customer's needs.

Decision box 466 indicates that after the carrier has notified thecaseworker that there are no changes to the Bill of Lading, the customersigns the Bill of Lading and this is proof of delivery. The earningsprocess is basically complete at this point.

Decision box 468 indicates for the carrier to EDI the freight bill tothe shipper, or EDI the date and time of delivery to the logisticsnetwork. This will further remove paper from the system.

Decision Box 470 shows that the shipper pays the freight bill byaccounts payable, without the of a paper freight

Decision Box 472 queries whether the customer pays the shipper or rathermakes any deduction on the invoice that's in addition to the agreed uponOS&D, or maybe none was is reported, the customer still may benonetheless take a deduction on the invoice Decision Box 474 shows thatshipper requests a copy of the Bill of Lading from the carrier when thecustomer does not pay the shipper. Anytime there is a shortage in areceivable amount from the carrier that's not justified or documented, acopy of the Bill of Lading is requested from the carrier. Thisinformation is used to adjust accounts receivable, if appropriate. Theyare required to be kept on file for six years by the ICC. This is theonly time that this piece of paper is required to be delivered to theshipper. If the customer does pay the shipper the full amount, then Box476 shows that the C. is closed and cash is to be applied fully if thereare no discrepancies in accounts receivable. The C.O. was closed earlierin the process.

IV. Inventory Management

Referring to FIG. 21, there is shown a diagrammatic representation ofproduct flow within this order management system. At the head of thediagram is shown the production area (400) where as pallets (402) comeoff the receiving line and a bar code license plate is attached. Eachpallet (402) is scanned and counted as it is loaded on the pallet train.

This information is fed into the inventory management system thatconnects across the AS/400 network. The pallets (402) are loaded fromthe receiving train and the license plate and quantity are scanned inthe receiving area (404). If there is an error it must be correctedbefore the pallet (402) is taken into the warehouse. Next each pallet(402) is stored (406) and the location is scanned. Each time a pallet(402) is moved from one location to another the pallet (402) is scannedand counted and a new location is scanned. Likewise there is holdrelease process (408) where a hold is put on pallets (402) and recordedin data base. Pallets (402) marked hold cannot be shipped until they arereleased. The pallets when pulled are moved to a shipping area (410) andif partial pallet usage is required, this information is recorded beforepallets (402) are moved back to storage (406). The shipment is readiedfrom these pallets, and is loaded and Bills of Lading issued.

Shown in FIG. 22 is a diagram of the software function supporting theinventory process previously described.

Shown in FIG. 23 is the hardware system that supports inventorymanagement and control. Hand-held devices (412, 414, 416 and 418) areused in the warehouse to scan pallet license plates and to updateinformation to the data base. The scanned data is received by repeaters(420) and relayed to a base station (422) where through a network (422),this data is related to PCs (428, 430). Information then flows to thenetwork server (432) which supports the inventory function andinformation likewise flows from this network into the reports andadministration function where financial records and the like arecreated.

FIG. 24 illustrates in diagrammatic function the normal cycle ofinventory management. It shows the functions as they interrelate one toanother. Particularly the production Ha planning (434), production(436), quality assurance (438) and purchasing (440), interacting withproduction receiving (442) and vendor receiving (444), to create thenecessary-records and instructions for the putting away (446) ofinventory. Likewise the order management function (448) inputs data forworkload planning (450) to assist in making a decision of which goods touse and to pick and load the goods for the carrier (454) and to closeout (456) the order and report the information to the logisticsfunctions (104) and feed back information to the order management system(448).

FIG. 25 shows the logic tree for the production and receiving functionas implemented in this system and tracks through the product beingreceived from production, palletized, inspected and then delivered tothe warehouse where the product is put away and this product is enteredinto inventory or quarantine with a data base created on location by SKUnumber, lot, quantity and reason for hold, if it is held in quarantine.

FIG. 26 is the vendor receiving diagram showing the decision tree forthe software to support this function and commences with the receipt ofpaperwork for items received. The information also is transmitted tologistics (104) at the same time to note the time of arrival of itemsreceived from vendors. Once again, there is an inspection function. Ifthere is a problem, then the material is rejected and the vendornotified. If there is no problem, then the trailer is identified andunloaded and its contents tallied. Once again, if there is a problem,the buyer is notified so that they may contact the vendor. After thematerial is properly documented and inspected it is then delivered tothe warehouse for putting away (446) and the information on the materialis inputted into the system data base for further use including thepurchasing data base to support an Electronic Catalog, described later.

FIG. 27 is a decision tree on the put away (446) function. Put away(446) is the function of storage of items in inventory. As pallets (402)are received, identification is entered using the license plate, aspreviously described. The pallet (402) after being identified ispromptly moved to a put away (446) location which has been identifiedfor it. This information is fed into the data base where the systemdetermines if the location is appropriate for it based upon factors suchas the frequency of use and the size and weight of the load. Productsused more frequently tend to be moved to the front of the warehousewhere they can be pulled more quickly. Heavier products tend to beloaded lower in the stack than lighter products. If the location isokay, there is a count made and prompt put away (446) is accomplished.As part of the information in this inventory system are coded dates todetermine if there are perishable items that need to be moved withincertain dates and this is also noted in the inventory records.

Referring to FIG. 28, workload planning, information on loads arereceived from the logistics function (102) as a basis to create receiveorders (458) with estimated work effort (460) involved to provide apreplan for appointments (462). A carrier calls for appointment fordelivery of goods and makes a dock appointment (464). If the carrier isunable to make appointments, this information is fed to logistics (102)where their records are updated as well.

Referring to FIG. 29 there is shown the order of pick function indiagrammatic fashion. The decision tree is used to represent functionsembodied in the system software to support the function. Orders are usedto create a selection process based upon the license plate of a pallet(402) to determine the goods stored on the pallet (402). Thisinformation is used to go to a picked location based upon the code datesso that perishable items are picked within their date rules first aswell as the maximizing of the use of pallets by picking full pallets ifthat's what an order calls for, or partial pallets if not. As theprocess continues the driver goes to the location designated and if theproduct is there he picks the product and records it in a hand helddevice which then immediately feeds the information on location, SKU,lot and quantity back into the inventory management system through thehand held network and the driver then delivers his load to itsdestination in the system. A unique feature of this system is that usingdouble-long forks, load picking can be maximized to route a driver topick two pallets in adjacent locations, or in at least nearby locations,rather than run back and forth on a pick cycle. If the driver goes tothe location and there is no product there he then puts a request backinto the system to verify the request and location if it comes back thesame way, he then inputs this information into the system to create acycle count that will then update the inventory system to show thatthere is an error and the product is not at the place indicated. Thecycle count request will then initiate the second query into whether theinventory is available. If it's not, then there's a notification to thesystem that there is a short order and this information on variances isfed back to logistics and to management functions where it can bereconciled in a new product order. If the inventory is available, thenthis information is fed back into the system and a new pick order isgenerated. Both the availability and non-availability of inventory arefed back into the system so that the system data base can be updated torespond to future pick orders.

Referring to FIG. 30, shown here is a batch pick function indiagrammatic fashion. Once again a select order of goods is initiatedand the location then is generated for the driver based upon code daterules and whether full pallet or partial pallet are requested. Thedriver goes to the location to see if the product is there. If theproduct is not there, as in the previous order pick function, the cyclecount request is initiated to determine if there is a short order, andif the inventory is available at another location. This information isfed back into the system once again. If the product is there, there is arecord made of the pull of the product by location, SKU lot andquantity. The load is then-moved to the staging area from which theorder is picked. A record of the pick is made and if there is a partialpallet picked, then the quantity on the pallet is updated by licenseplate, SKU, lot and quantity. The pallet is then delivered to thewarehouse after the goods have been picked for putting away.

Referring to FIG. 31, there is shown an order, load and closeoutfunction in diagrammatic fashion. Once again the diagram indicates thelogic of the software implementing this function. Having previouslydescribed the functions of picking an order and the loading of theorder, the description shown here is further a description of theprevious function except for the gathering of documents where there isan export of the goods and appropriate Bills of Lading must be createdas well as grade and quality certificates are created and signatures areobtained for the files as needed. After the order has been loaded andthe updates and variances noted, the order is closed out and thisinformation is transmitted to logistics and the order managementfunction. Referring to FIG. 32 there is shown the cycle count functionin diagrammatic fashion as implemented by software in the system. Thecycle count provides for correcting inventory problems that areidentified in the warehouse. The inventory problems could arise fromwrong location of storage of products, wrong SKU number or lot problem.The cycle count is implemented by a visual scan that then enters theinformation of location SKU, lot and quantity. If this information isokay, then that data is fed back into the data base. If it's not, thereis a recount initiated resulting in a further query of whether theinformation is okay. If it is okay it gets fed back in the system toindicate that. If not, the inventory is updated. All of this is donewithout paper and is done in a real time fashion using hand-heldinstruments to input the data into the inventory management data base.

Referring to FIG. 33, there is shown in diagrammatic fashion theyear-end fiscal accounting of inventory. Some of the functions have beendescribed previously and for simplicity reference is made to thisdiagram which is fully descriptive of the inventory count process.

Referring to FIG. 34, the consolidation function is shown indiagrammatic fashion as implemented by software in this system. Adecision is made in software as to what to do with the product received.The decisions can be to place it on a pallet, at which point in time theold pallet data from which this product was pulled is entered, includingticket and quantity and a new pallet ticket is created. If the decisionis to place the material in a slot, the material is moved to a locationwhere the pallet information and the old tag location is entered tocreate a new location identification. Alternatively, if the decision isto make a manual move of the product, then the old pallet data isentered as well as the new location that the pallet will be moved to, toupdate the records for the inventory system.

Referring to FIG. 35, there Us shown the return system and documentfunction. As returns are received, logistics is informed of the time ofarrival of the goods. Simultaneously the truck is unloaded. Theinformation on the material, such as quantity and the shippinginformation is entered into the system and the customer representativeis fed this data on line before the product goes back into theinventory. There is a quality check and after making disposition on thequality, a decision is made as to whether to put the product intoquarantine or back into inventory.

Referring to FIG. 36, there is shown in diagrammatic fashion the outsidestorage decision process. When an order is received, the decision ismade as to whether it's going to be used for production or needs to bestored. If the decision is for storage, the carrier is contacted and thematerial is moved to storage where the data on the location and theretrieval cycle is entered. There is electronic data communication withthe warehouse storage to update the product/lot, code, date and numberof pallets and this information is simultaneously provided to receivingto create records of the goods coming into the system and having beenidentified as being stored outside of the shipper's facility.

V. Purchasing

Referring to FIG. 37, there is shown a process of standardizedpurchasing. By standardizing purchases, the process of acquiringmaterials for the system is streamlined. This is accomplished bycreating blanket vendor agreements that have sufficient data onquantity, shipments, charges, delivery times and availability that thisinformation can be entered into an electronic catalog (EC) for use by auser having access to the system.

Referring to FIG. 38, there is shown in diagrammatic function theelectronic catalog. The different functions of the system using theelectronic catalog are noted on this diagram. The purchasing function isnotable in which requests for quotations are prepared based upon itemusage and vendor performance. The analysis for quotes is accomplished bycontract management system which provides for the monitoring ofcontracts vendors. Subsequent vendor's performance is monitored. All ofthis is entered into the data base. Likewise the supplier managementteam, designated by SMT, examines item usage and inquiries as well asordering patterns to determine the historical basis of future orderrequirements, thereby creating a decision basis as to what inventory touse to create a data base of items to be made available on theelectronic catalog. The items will be standardized to the extentpossible and fewer vendors approved to minimize the amount oftransactions necessary for procuring repetitive standardized items.Likewise the information on receipt of goods for receiving, schedulesand receipt transactions are supported by the electronic catalog.Managers may make selections from the electronic catalog using on-lineapproval procedures based upon approved budgets. This information is fedback in the budget and expenditure monitoring programs to update thefinancial projections for the year-end to determine if the budget is ontarget or otherwise out of performance. The electronic catalog also maybe updated by vendors, including price updates, if there is approval forthat practice with the vendor.

Referring to FIG. 39, there is shown electronic catalog information andstorage. The electronic catalog stores information on vendors by requestfor quotation, quotes received, whether there are contracts in place, aswell as vendor performance and maintains an EDI profile of the vendor todetermine how to communicate with it. The electronic catalog alsomaintains records on purchasing transactions with the request for items,releases those purchase order requests, and notes the receipt of theitems. Vendor catalogs also may be included in the electronic catalog ifcompatible. Items in the catalog are grouped by commodities, types andclass and there is an inventory strategy as to the stocking ofcontinually used items, if appropriate. The electronic catalog alsonotes location by company, division, department, user and approvalhierarchy. In this fashion the goods may be identified at any point intime and if necessary retrieved.

Referring to FIG. 40, there is shown in diagrammatic relationship, theelectronic catalog (500) and how it accesses information throughout thesystem. It can be seen that the electronic catalog (500) worksthroughout this network to update (120) accounts payable as well as toshow when there has been a payment to or by a vendor. The electroniccatalog (500) also interacts with the human resources input system (502)to identify approved users in the system. The electronic catalog (500)also interacts with the transportation, maintenance technique inventorysystem (504) to identify items for the fleet maintenance system. Theelectronic catalog (500) also interacts with the ELKE maintenance system(506), and the MRO inventory (508), which is a store room inventorysystem, to see if items are in stock and to respond to a request by auser, versus having to order the items from the catalog. The EC alsointeracts with the PRISM software (170) to update inventory records. Aspreviously stated, the electronic catalog (500) interacts with thevendor (510) to receive quotes and to ask the vendor (510) for requestsfor quotations and transmit contracts back and forth. This communicationis by EDI, supplemented by fax, phone and release orders, ifappropriate. The electronic catalog notes receipts of goods (512), soits data base may be updated.

Modifications and variations, of the above-described embodiments of thepresent invention are possible, as appreciated by those skilled in theart in light of the above teachings.

It is therefore to be understood that, within the scope of the appendedclaims and their equivalents, the invention may be practiced otherwisethan as specifically described.

1. A method for creating an electronic catalog and processing purchaserequests comprising: requesting a vendor quotation; creating a blanketvendor order; entering the blanket vendor order in the electroniccatalog, wherein the electronic catalog comprises a plurality of items,quantities, shipment charges delivery times and availabilities; creatinga pre-approved budget; creating a purchase request; requesting an itemfrom the plurality of items electronic catalog using the purchaserequest; communicating said order from the electronic catalog to avendor; receiving acknowledgment of the communicated order; receivingthe ordered item; and recording receipt of said item.
 2. A method asrecited in claim 1, further comprising: creating an accounts payablerecord initiated by said record of receipt; and placing the item in aninventory.
 3. A method as recited in claim 1, wherein receiving theorder further comprises: creating a carrier data base containinginformation to determine shipping costs and delivery schedules; tendingan offer of shipment to a selected carrier; and receiving confirmationfrom the carrier.
 4. A system for creating an electronic catalog,comprising: means for purchasing an item; means for creating a graphicaluser interface for a customer service representative to input an order;means for tendering a load to a carrier for shipment; means for creatingan automated warehousing ticket; and means for creating an electroniccatalog based on a blanket vendor agreement wherein said electroniccatalog comprises a plurality of items, quantities, shipment charges,delivery times and availabilities.
 5. The system of claim 4, wherein themeans for purchasing an item further comprises: means for creating ablanket vendor order; means for providing user input to generate arequisition request to requisition the item; means for processing therequisition request by comparing said requisition request to the blanketvendor agreement to determine the availability of the item; means forchecking the availability of funds against a budget to approve apurchase transaction; means for communicating a purchase request and apurchase release to a vendor; and means for acknowledging the purchaserequest.
 6. The system of claim 5, wherein the means for purchasing anitem further comprises: means for receiving the item; means for creatinga record of the receipt; means for creating an accounts payable recordinitiated by said record of receipt; and means for placing the item inan inventory.
 7. The system of claim 4, wherein the means for creating agraphical user interface for a customer service representative, furthercomprises: means for creating screens in a window context with multiplefiles, said screens having buttons to control access to files, whereinsaid buttons are used to access customer records.
 8. The system of claim4, wherein the means for tendering a load to a carrier for shipmentfurther comprises: means for creating a carrier data base containinginformation to determine shipping costs and delivery schedules; meansfor tendering an offer of shipment to a selected carrier; and means forreceiving confirmation from the carrier.
 9. The system of claim 4,wherein the means for creating an automated warehousing ticket furthercomprises: means for generating pick-order data for an item; means forpicking the item from an inventory; means for creating a record of thepicked item; means for transmitting said pick-order data to a centraldata base in real time; means for delivering the picked item to ashipping point; means for transmitting data representing delivery of theitem for shipment to said data base; and means for consolidating saidpick-order and shipment data into a record in said data base.
 10. Thesystem of claim 4, wherein the means for creating an electronic catalogfurther comprises: means for requesting a vendor quotation; means forcreating a blanket vendor agreement having a plurality of items,quantities, shipment charges, delivery times and availabilities; meansfor entering said blanket vendor agreement into the electronic catalog;means for creating a pre-approved budget; means for creating a purchaserequest; means for requesting an item from the electronic catalog; meansfor communicating said blanket order to a vendor; means for receivingacknowledgement of a blank order request; means for receiving saidordered item; and means for receiving receipt of said item.
 11. A methodfor processing customer orders in a computer-based processing systemhaving a plurality of data processing devices electrically connected tocommunicate with each other, comprising: requesting a vendor quotation;creating a blanket vendor agreement; entering said blanket vendoragreement into an electronic catalog: receiving a customer order from acustomer order input terminal; processing the customer order using aninterface module accessed through the customer order input terminal,said interface module coordinating access to the electronic catalog andcontrolling interaction between a user and said electronic catalog;generating the customer order in response to data inputs from the userthrough said customer order input terminal and data from said electroniccatalog; automatically checking an inventory for availability of an itemcorresponding to the customer order in response to the customer order byaccessing an inventory data base; retrieving the item from the inventoryby accessing an inventory storage location data base; building a loadfor shipment from the retrieved item; and scheduling delivery of theload to the customer.
 12. A method for a processing customer order usinga networked computer-based data processing system, comprising:requesting a vendor quotation; creating a blanket vendor order; enteringsaid blanket vendor order into an electronic catalog; receiving acustomer order from a customer order input terminal; processing thereceived customer order to generate a customer order in response to datainputs from a user; automatically checking an inventory for availabilityof an item corresponding to the customer order by accessing theelectronic catalog; retrieving the item by accessing an inventorystorage location data base; building a load for shipment containing theretrieved item; and scheduling the load for delivery to the customer.